SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[spAddEmployee]
@Name NVARCHAR(50),
@Gender NVARCHAR(50),
@City NVARCHAR(50),
@DateOfBirth DATETIME
AS
BEGIN
INSERT INTO dbo.tblEmployee
        ( Name, Gender, City ,DateOfBirth)
VALUES  (@Name,@Gender,@City,@DateOfBirth    )
end



		  
GO
